<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>CRM配置知识点</title>
</head>
<body>
<p>知识</p>


<h2>资费要求服务</h2>

<h2>服务要求资费</h2>

<h2>服务定价</h2>

INSERT INTO prod.serv_spec 
(serv_spec_id,serv_spec_type_cd,spec_status_cd,area_id,name,is_inst,manage_code,
start_dt,end_dt,contain_item,VERSION,simple_spell,contain_time)
VALUES
(700026025,1,2,10000,'翼机通公交卡','Y',680000036,
SYSDATE,to_date('01-01-3000', 'dd-mm-yyyy'),'N',SYSDATE,'yjtgjk','N');

INSERT INTO prod.serv_spec_2_category_node (category_node_id,serv_spec_id,seq_id)
VALUES(11100,700026025,1);

INSERT INTO prod.sspec_comp_grp_2_sspec (sspec_comp_grp_id,serv_spec_id,min_qty,max_qty,comp_order)
VALUES
(706,700026025,0,1,0);

INSERT INTO prod.sspec_comp_grp_2_sspec (sspec_comp_grp_id,serv_spec_id,min_qty,max_qty,comp_order)
VALUES
(10153,700026025,0,1,0);

INSERT INTO prod.serv_spec_2_area (serv_spec_id,area_id,display_cd,status)
VALUES
(700026025,11000,1,1);


INSERT INTO prod.price_plan (PRICE_PLAN_CD, NAME, MANAGE_CODE, DESCRIPTION, PRICE_PLAN_TYPE_CD, 
PRICE_PLAN_LEVEL_CD, TIME_UNIT_CD, MIN_EFF_TIME, PP_COMP_TYPE_CD, START_DT, END_DT, VERSION, DEFAULT_EFF_TIME,
MAX_EFF_TIME, AREA_ID, PP_RATE_TYPE_CD, PP_TARGET_TYPE_CD, TARGET_ID, SPEC_STATUS_CD, MUST_USE_TIME,
PRICE_PLAN_DISPLAY_CD, DEFAULT_START_DT, DEFAULT_END_DT, DEFAULT_START_TIME_FIRST, DEFAULT_START_TIME, DEFAULT_EFF_TIME_FIRST)
VALUES (980010193, '翼机通公交卡开户费', '800000000', 
'一次性开户调试费用30元', 2,
3, 7, NULL, 1, SYSDATE, to_date('01-01-3000', 'dd-mm-yyyy'), SYSDATE,NULL,
NULL, 10000, 1, 2, NULL, 2, NULL,
1, NULL, NULL, NULL, NULL, NULL);

SELECT * FROM prod.charge_item ci WHERE  ci.manage_code='90058';
INSERT INTO prod.charge_item 
(charge_item_cd,name,manage_code,description,charge_item_type_cd,area_id,def_pay_method_cd,limit_redo,print_name,charge_item_status_cd,want_print)
VALUES
(90058,'翼机通公交卡开户费',90058,'',1,10000,1,'N','翼机通公交卡开户费',2,'Y');

SELECT a.*,ROWID FROM charge_item_2_pay_method a WHERE a.charge_item_cd=90058;
SELECT * FROM crm.pay_method;
INSERT INTO prod.charge_item_2_pay_method (charge_item_cd,pay_method_cd,seq_id)
VALUES (90058,1,0);
INSERT INTO prod.charge_item_2_pay_method (charge_item_cd,pay_method_cd,seq_id)
VALUES (90058,8,0);
INSERT INTO prod.charge_item_2_pay_method (charge_item_cd,pay_method_cd,seq_id)
VALUES (90058,4,0);

INSERT INTO prod.pp_counter_charge (price_plan_cd,charge_item_cd,charge)
VALUES (980010193,90058,3000);
INSERT INTO prod.serv_busi_price 
(offering_pp_cd,serv_spec_id,order_type_id,serv_level_cd,price_plan_cd,grp_id,start_dt,end_dt,offering_id)
SELECT 1,700026025,30,1,980010193,1,SYSDATE,to_date('01-01-3000', 'dd-mm-yyyy'),o.offering_id FROM prod.offering o
WHERE o.prod_spec_id IN (378,379);
INSERT INTO intf.Crm_Ocs_Code_Map (map_type,crm_code,crm_desc,ocs_code,ocs_desc)
VALUES(2,700026025,'翼机通公交卡',680000036,'翼机通公交卡');


</body>
</html>